CREATE TABLE "iws_merge_task_record"
(
    "id"               VARCHAR(50) PRIMARY KEY,
    "task_id"          VARCHAR(50) NULL DEFAULT NULL,
    "item_bar_code"    VARCHAR(50) NULL DEFAULT NULL,
    "container_source" VARCHAR(50) NULL DEFAULT NULL,
    "container_target" VARCHAR(50) NULL DEFAULT NULL,
    "weight"           VARCHAR(50) NULL DEFAULT NULL,
    "floor"            VARCHAR(50) NULL DEFAULT NULL,
    "create_name"      VARCHAR(50) NULL DEFAULT NULL,
    "create_date"      DATETIME    NULL DEFAULT NULL,
);
exec sp_addextendedproperty 'MS_Description', N'主键id', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'id'
go
exec sp_addextendedproperty 'MS_Description', N'任务单号', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'task_id'
go

exec sp_addextendedproperty 'MS_Description', N'物料条码', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'item_bar_code'
go
exec sp_addextendedproperty 'MS_Description', N'源点载具', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'container_source'
go
exec sp_addextendedproperty 'MS_Description', N'终点载具', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'container_target'
go
exec sp_addextendedproperty 'MS_Description', N'物料重量', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'weight'
go
exec sp_addextendedproperty 'MS_Description', N'仓库', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'floor'
go
exec sp_addextendedproperty 'MS_Description', N'建单账号', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'create_name'
go
exec sp_addextendedproperty 'MS_Description', N'建单时间', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'create_date'
go
